<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script language="javascript" type="text/javascript" src="flashobject.js"></script>
<style type="text/css">
<!--
body{
margin-top:0px;
margin-right:0px;
margin-left:0px;
}

.NormalTex {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 11px;
	color: #333;
	text-align: left;
}

#navegador{
		
		float:left;
	margin-left:7px;
	}


#navegador ul{
   list-style-type: none;
   text-align: center;
}
#navegador li{
   display: inline;
   text-align: center;
   margin: 0 10px 0 0;
   
}
#navegador li a {
   padding: 2px 7px 2px 7px;
   color: #666;
   background-color: #eeeeee;
   border: 1px solid #ccc;
   text-decoration: none;
}
#navegador li a:hover{
   background-color: #333333;
   color: #ffffff;
}
#navegador li .act{
   background-color: #333333;
   color: #ffffff;
}

-->
</style>

<title>Lectura de registros de una tabla</title>

</head>

<body>
<table width="931" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td colspan="2" height="10">    </td>
  </tr>
  
  <tr>
    <td width="4">&nbsp;</td>
    <td width="927"><img src="logo.jpg"  border="0"/></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><!--#include file="cnxBd.asp"--> 
<%
'Ahora creamos la sentencia SQL que nos servira para hablar a la BD
sSQL="Select  * from calc_instaladores2c order by codigo desc"
'Ejecutamos la orden 
set RS = Conn.Execute(sSQL)
'Mostramos los registros
%></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><div id="tipo"><strong>Comercial </strong> </div>
<div id="navegador">
<ul>
<li><a href="listadoc1.asp" >Caso 1</a></li>
<li><a href="listado2c.asp" class="act">caso 2</a></li>
<li><a href="listado3c.asp">Caso 3</a></li>
<li><a href="listado4c.asp">caso 4</a></li>
</ul>
</div></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><table width="923" border="1" cellpadding="0" cellspacing="0" >
      <tr class="tr"  >
        <th width="39" class="NormalTex"><div align="center"><span>Codigo</span></div></th>
		
		<th width="63" class="NormalTex"><div align="center"><span>Num.Regist</span></div></th>
		
        <th width="68" class="NormalTex"><div align="center"><span>Dirección Proyecto</span></div></th>
		<th width="55" class="NormalTex"><div align="center"><span>Nombre del instalador</span></div></th>
		
		<th width="44" class="NormalTex"><div align="center"><span>Numero</span></div></th>
		<th width="40" class="NormalTex"><div align="center"><span>Distrito</span></div></th>
		
		<th width="40" class="NormalTex"><div align="center"><span>Dirección</span></div></th>
		<th width="40" class="NormalTex"><div align="center"><span>N.Departamento</span></div></th>
		<th width="40" class="NormalTex"><div align="center"><span>Medidor</span></div></th>
		<th width="40" class="NormalTex"><div align="center"><span>Regulador</span></div></th>
		
		<th width="42" class="NormalTex"><div align="center"><span>Cod.Ing</span></div></th>
		
		<th width="57" class="NormalTex" bgcolor="#F0F0F0"><div align="center"><span>Artefacto1</span></div></th>
		<th width="39" class="NormalTex" bgcolor="#F0F0F0"><div align="center"><span>Tramo BC <br>
		(m)</span></div></th>
		<th width="53" class="NormalTex" bgcolor="#F0F0F0"><div align="center"><span>Diametro Nominal BC</span></div></th>
		
		<th width="57" class="NormalTex"><div align="center"><span>Artefacto2</span></div></th>
		<th width="39" class="NormalTex"><div align="center"><span>Tramo BD <br>
		(m)</span></div></th>
		<th width="53" class="NormalTex"><div align="center"><span>Diametro Nominal BD</span></div></th>
		
		<th width="39" class="NormalTex" bgcolor="#F0F0F0"><div align="center"><span>Tramo AB</span></div></th>
		<!--<th width="100" class="NormalTex"><div align="center"><span>Material</span></div></th>-->
		<th width="57" class="NormalTex" bgcolor="#F0F0F0"><div align="center"><span>Diametro Nominal AB</span></div></th>
		
		<th width="54" class="NormalTex"><div align="center"><span>Potencia Nominal<br> (kw)</span></div></th>
		<th width="88" class="NormalTex"><div align="center"><span>Longitud Equivalente</span></div></th>
        <!--<th width="99"><div align="center"><span class="Estilo1">Modificar</span></div></th>
        <th width="118"><div align="center"><span class="Estilo1">Eliminar</span></div></th>-->
      </tr>
      <%
Do While Not RS.Eof
%>
      <tr  bgcolor="#FFFFFF">
        <td class="NormalTex" align="center"><div align="center"><%=RS("codigo")%></div></td>
		
		<td class="NormalTex" align="center"><div align="center"><%=RS("nregistro")%></div></td>
		
        <td class="NormalTex"><%=RS("nombre1")%></td>
		<td class="NormalTex"><%=RS("nombre2")%></td>
		
		<td class="NormalTex"><%=RS("numdirec")%></td>
		<td class="NormalTex"><%=RS("disdirec")%></td>
		
			<td class="NormalTex"><%=RS("regulador")%></td>
				<td class="NormalTex"><%=RS("direccion2")%></td>
					<td class="NormalTex"><%=RS("medidor")%></td>
						<td class="NormalTex"><%=RS("num2")%></td>
		
		<td class="NormalTex"><%=RS("coding")%></td>
		
		
		<td class="NormalTex"><%=RS("artef1")%></td>
		<td class="NormalTex" align="center"><div align="center"><%=RS("tramobc")%></div></td>
		<td class="NormalTex" align="center"><div align="center"><%=RS("diametrobc")%></div></td>
		
		<td class="NormalTex"><%=RS("artef2")%></td>
		<td class="NormalTex" align="center"><div align="center"><%=RS("tramobd")%></div></td>
		<td class="NormalTex" align="center"><div align="center"><%=RS("diametrobd")%></div></td>
		
	<td class="NormalTex" align="center"><div align="center"><%=RS("tramoab")%></div></td>
		<td class="NormalTex" align="center"><div align="center"><%=RS("diametroab")%></div></td>
      <td class="NormalTex" align="center"><div align="center"><%=RS("potencian")%></div></td>
	  <td class="NormalTex" align="center"><div align="center"><%=RS("longitude")%></div></td>
      </tr>
      <%
RS.MoveNext
Loop
'Cerramos el sistema de conexion
Conn.Close
%>
    </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>

</body>
</html>


